how sql subquery works

visit shbcf.ru